| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Erica Northman
Phoenix Co.
0
   |
Posted - 2013.07.14 18:57:00 -
[1] - Quote
WARN: Caching invalid API XML for corp/CorporationSheet
Im getting this error. Any idea how to fix this ? |
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.15 20:39:00 -
[2] - Quote
I have the lasest hg.
2013-07-15 20:34:59.793
WARN: Insert/upsert failed for utilXmlCache
File: /*yapeal/class/YapealQueryBuilder.php(493)
2013-07-15 20:34:59.796
WARN: mysqli error: [2006: MySQL server has gone away] in EXECUTE("truncate table `eveAllianceList`")
Code: 2006
Trace:
#0 /*yapeal/ext/ADOdb/adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 2006, 'MySQL server ha...', 'truncate table ...', false, Object(ADODB_mysqli))
#1 /*yapeal/ext/ADOdb/adodb.inc.php(1017): ADOConnection->_Execute('truncate table ...', false)
#2 /*yapeal/class/api/eve/eveAllianceList.php(188): ADOConnection->Execute('truncate table ...')
#3 /*yapeal/class/api/AApiRequest.php(112): eveAllianceList->prepareTables()
#4 /*yapeal/class/SectionEve.php(113): AApiRequest->apiStore()
#5 /*yapeal/yapeal.php(164): SectionEve->pullXML()
#6 {main}
--------- END TRACE ----------
File: /*yapeal/class/api/eve/eveAllianceList.php(195)
2013-07-15 20:34:59.796
WARN: Could not prepare eveAllianceList API tables to accept new data for 0
File: /*yapeal/class/api/AApiRequest.php(115)
2013-07-15 20:34:59.797
FATAL: Uncaught exception in yapeal.php
File: /*/yapeal/yapeal.php(183)
2013-07-15 20:34:59.797
FATAL: Failed to get ADOFieldObjects for columns in YapealQueryBuilder
Trace:
#0 /*/yapeal/class/api/eve/eveAllianceList.php(84): YapealQueryBuilder->__construct('eveAllianceList', 'mysqli://fredri...')
#1 /*/yapeal/class/api/AApiRequest.php(126): eveAllianceList->parserAPI()
#2 /*/yapeal/class/SectionEve.php(113): AApiRequest->apiStore()
#3 /*yapeal/yapeal.php(164): SectionEve->pullXML()
#4 {main}
--------- END TRACE ----------
File: /*/yapeal/yapeal.php(184)
|
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.15 20:39:00 -
[3] - Quote
Erica Northman wrote:I have the lasest hg.
2013-07-15 20:34:59.793
WARN: Insert/upsert failed for utilXmlCache
File: /*yapeal/class/YapealQueryBuilder.php(493)
2013-07-15 20:34:59.796
WARN: mysqli error: [2006: MySQL server has gone away] in EXECUTE("truncate table `eveAllianceList`")
Code: 2006
Trace:
#0 /*yapeal/ext/ADOdb/adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 2006, 'MySQL server ha...', 'truncate table ...', false, Object(ADODB_mysqli))
#1 /*yapeal/ext/ADOdb/adodb.inc.php(1017): ADOConnection->_Execute('truncate table ...', false)
#2 /*yapeal/class/api/eve/eveAllianceList.php(188): ADOConnection->Execute('truncate table ...')
#3 /*yapeal/class/api/AApiRequest.php(112): eveAllianceList->prepareTables()
#4 /*yapeal/class/SectionEve.php(113): AApiRequest->apiStore()
#5 /*yapeal/yapeal.php(164): SectionEve->pullXML()
#6 {main}
--------- END TRACE ----------
File: /*yapeal/class/api/eve/eveAllianceList.php(195)
2013-07-15 20:34:59.796
WARN: Could not prepare eveAllianceList API tables to accept new data for 0
File: /*yapeal/class/api/AApiRequest.php(115)
2013-07-15 20:34:59.797
FATAL: Uncaught exception in yapeal.php
File: /*/yapeal/yapeal.php(183)
2013-07-15 20:34:59.797
FATAL: Failed to get ADOFieldObjects for columns in YapealQueryBuilder
Trace:
#0 /*/yapeal/class/api/eve/eveAllianceList.php(84): YapealQueryBuilder->__construct('eveAllianceList', 'mysqli://fredri...')
#1 /*/yapeal/class/api/AApiRequest.php(126): eveAllianceList->parserAPI()
#2 /*/yapeal/class/SectionEve.php(113): AApiRequest->apiStore()
#3 /*yapeal/yapeal.php(164): SectionEve->pullXML()
#4 {main}
--------- END TRACE ----------
File: /*/yapeal/yapeal.php(184)
Any idea why I get this ?
* = removed the home directory listing. |
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.15 20:41:00 -
[4] - Quote
Sorry alot of issues here.
I still have no rows in corpCorporationSheet. Uploaded and cleared cache. yapeal running every minute via cron.
log/yapeal_warning says this:
WARN: Caching invalid API XML for corp/CorporationSheet
File: /*yapeal/class/YapealApiCache.php(192)
2013-07-15 16:05:22.371
WARN: Caching invalid API XML for corp/CorporationSheet
File: /*/yapeal/class/YapealApiCache.php(192)
and I have updated via hg today. Did 3 changes or something. Also did the install/mysqlcreatetables. |
Erica Northman
Phoenix Co.
0
|
Posted - 2013.07.16 11:21:00 -
[5] - Quote
Dragonaire wrote:Erica Northman - See post 330 on this thread about possible cause as it's the most common cause of your error especially in Windows.
Not running Windows, but Centos 6.
max_allowed_packet fixed it :) ty.
It also fixed the corpCorporationSheet problem. |
Erica Northman
Phoenix Co.
3
|
Posted - 2013.08.03 09:27:00 -
[6] - Quote
Somerset Mahm wrote:I use Yapeal to track almost 20 characters' worth of jobs. What kind of keys are you using to track the jobs?
Are there any restrictions of how many characters/corporations u can track with Yapeal? I theory could u track 1000 corporations?  |
Erica Northman
Phoenix Co.
3
|
Posted - 2013.08.03 11:05:00 -
[7] - Quote
Louis Vitton wrote:In theory there is no restriction i am aware of in the software. However CCP may or may not allow you to do this as you would put a heavy load on their server requesting that much data all the time.
**Please note this is what i am aware of from my use of yapeal.
Buyt yapeal checks cache and does not query the API-server unnecessary? And how does EVE-KILL do it? They do alot of pulling requests. |
| |
|